﻿CREATE TABLE [dbo].[dim_Zweck] (
    [ZweckID]             INT            NOT NULL,
    [ZweckName]           NCHAR (31)     NOT NULL,
    [ParentZweckID]       INT            NULL,
    [SubKategorieID]      INT            NULL,
    [Budget_monthly_2014] NUMERIC (8, 2) NULL,
    CONSTRAINT [PK_tblZweck] PRIMARY KEY CLUSTERED ([ZweckID] ASC),
    CONSTRAINT [FK_tblZweck_tblSubKategorie] FOREIGN KEY ([SubKategorieID]) REFERENCES [dbo].[dim_KategorieSub] ([SubKategorieID])
);

